|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
|
Addict
Joined: Apr 2002
Posts: 1,768 |
What's the best column type to use for a column which represents a boolean value (0 or 1)?
My guess is CHAR(1) NOT NULL.
I noticed that there's also a CHAR(0) NOT NULL, but its only permissible values are NULL and ''(empty string), which I think would be confusing.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 449
Joined: February 2008
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 2112
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 1
|
|
|
|
|
|
